Column | Data Type | Nullable | Default | Description |
LocationID | smallint | not null | | Primary key for Location records. |
Name | dbo.Name | not null | | Location description. |
CostRate | smallmoney | not null | ((0.00)) | Standard hourly cost of the manufacturing location. |
Availability | decimal(8, 2) | not null | ((0.00)) | Work capacity (in hours) of the manufacturing location. |
ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated. |